home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 8 / developer source - volume 8.iso / dbmsa / may96 / kimbf101.gif < prev    next >
Graphics Interchange Format  |  1996-11-15  |  37.3 KB  |  345x292  |  4-bit (16 colors)
   ocr: muitimilion-row jolns to verytarge Customerdimension purchases fecttable alongwitn product, customerkey store, andtme lame address more: constant cityestate demographicatributes birth date Ucoue hot totalpurchases. demographic attributes number.children education Figure 1. Very large Customer dimensions may have one million to 100 million records, The Customer dimension is joined to an even larger fact table through the customer key. The customer attributes usually can be clumped into more or less constant values together with "hot" demographic values whose changes needto be tracked.